UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E8wMv2W9Pd86W17L8fxR9qZxXVx7/yR1QD8NRVJw53I='
WHERE
key_id = 'b4992ecd1739f50c13af6bb8237bfcd64c90aa24b7f966a67cf7f9f5d3a2752a'
AND (
token = 'E8wMv2W9Pd86W17L8fxR9qZxXVx7/yR1QD8NRVJw53I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)