UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HODNmON3Lw+sbyRVS0JepmvsUoSHuOEPzq2/l5/inTs='
WHERE
key_id = '9b99da6b67ade4b0b9409273291cb3d55156e437710d465c575f3264fd3be5a9'
AND (
token = 'HODNmON3Lw+sbyRVS0JepmvsUoSHuOEPzq2/l5/inTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)