UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8hW0Lms3X5LZ4jkAaAmyuP3dr4x7I/ELx4jPKcJmdk='
WHERE
key_id = '7bacf2f5cf5b9ca0ef6acaf2b6d7baf8b64968c1c93838783c34e8bf34cbd2a6'
AND (
token = 'W8hW0Lms3X5LZ4jkAaAmyuP3dr4x7I/ELx4jPKcJmdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)