UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5hn0FVfkv91Ry2gqaCYGklZo+bFLSlxjsuqvu8i38Uo='
WHERE
key_id = 'a7e508023aae888e674f07d8c5b4869b22fe037e94f60a9a7cc8f7dc441ec121'
AND (
token = '5hn0FVfkv91Ry2gqaCYGklZo+bFLSlxjsuqvu8i38Uo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)