UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '74eZ2siwUS4BkxNRF3J0krXhO3PXEDTZmNWMznonzPA='
WHERE
key_id = 'a5eee338d2ba71540880f83c84a425530e5c270cc89e5efc2ba9dfe559490d14'
AND (
token = '74eZ2siwUS4BkxNRF3J0krXhO3PXEDTZmNWMznonzPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)