UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8eyJi81DYwO4Szemt+OPduTCmm+AjuGlwItbAo3gCdM='
WHERE
key_id = '22d497142854b3bff1ee31011e770ebfe294a4ba567fdddafa529a9cc3ba9120'
AND (
token = '8eyJi81DYwO4Szemt+OPduTCmm+AjuGlwItbAo3gCdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)