UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ikn0mRLiIMnuEJh2V2yjhlhzCkxlzet4QRffCi59XA='
WHERE
key_id = '778d501e4a255abe3d5b8b432eb7c48167e0b08b2a6b9e0ee77b170f750f8d40'
AND (
token = '8ikn0mRLiIMnuEJh2V2yjhlhzCkxlzet4QRffCi59XA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)