UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CBtxni33Sj5Qayyh6PR8ftsxF7FiIrPTLK3XL8d6tU='
WHERE
key_id = '5469abfbe96faf196c5a455d3838abc5a878303e51978f203a0379ce7e876960'
AND (
token = '8CBtxni33Sj5Qayyh6PR8ftsxF7FiIrPTLK3XL8d6tU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)