UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ecW/yrkl6bufJ0peKF8X41PjcVX168iDI/3yYqEK9J0='
WHERE
key_id = 'a2ee883a2bac12b943dd41b4b20e123fea80afefb25efbb18290747547ae7568'
AND (
token = 'ecW/yrkl6bufJ0peKF8X41PjcVX168iDI/3yYqEK9J0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)