UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xcj9buTtYUth8npK143EwmvcHwG2PhN7GyjMOIczaZM='
WHERE
key_id = 'a8144573f42bcd44c37210e82d605f383eb0f7dff53d1fde9189ba6663228f3f'
AND (
token = 'Xcj9buTtYUth8npK143EwmvcHwG2PhN7GyjMOIczaZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)