UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OsKST5iKO3VnttndHSfrH18ZDPCI19uFEN40BwaMW5g='
WHERE
key_id = 'a53baa3d8c30d89854f5f62db1b08ba00b10829018f5ab29bba4ebf5d06aaa1a'
AND (
token = 'OsKST5iKO3VnttndHSfrH18ZDPCI19uFEN40BwaMW5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)