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