UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SH8Ceo0dUJ15rmR7zQhAyqqCgWFI7Ml2SW/RMBJPyVw='
WHERE
key_id = 'e7cadf0bd1ff50a9c6a90c6deb596cb227a4d6443ba15ec3a4b076735d799d59'
AND (
token = 'SH8Ceo0dUJ15rmR7zQhAyqqCgWFI7Ml2SW/RMBJPyVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)