UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ixjrKJ3x/ANsU06dpYK1Z64n30rjsPJtJrHtMgj4Dw='
WHERE
key_id = '9868e253611141573525c60fada762ae4f8de41f00154b28e1ecf66e99bf55fb'
AND (
token = '0ixjrKJ3x/ANsU06dpYK1Z64n30rjsPJtJrHtMgj4Dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)