UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YKl4/0VEvf8zu6d0VoDvCVLW5Pf7rpbEM2xau4vtSVc='
WHERE
key_id = 'e1aedcd89346742fab8a6fe4e80c9f050cf69a7b4d167aef0975297eb7040ce1'
AND (
token = 'YKl4/0VEvf8zu6d0VoDvCVLW5Pf7rpbEM2xau4vtSVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)