UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ck27LvBZVxxJnVTf/gb5hLjGbni+UPIBxdtt+yXumb0='
WHERE
key_id = 'ab60a33ed59af55e2caf8b8dbc13f09b1177cdbccddac455ed9c50e7249d7b90'
AND (
token = 'ck27LvBZVxxJnVTf/gb5hLjGbni+UPIBxdtt+yXumb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)