UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SZXnscd+GV50AaeWdVdcUc7VnWy6jd37d4/pgj2Wjn4='
WHERE
key_id = 'dd2a8482fc37dfd6712f51636afa9c76f35421e948ab980c88ff8cb575a62565'
AND (
token = 'SZXnscd+GV50AaeWdVdcUc7VnWy6jd37d4/pgj2Wjn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)