UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QOg1TPACfW3wNxhY7KGWcBx7bHKZOikkbYmuu9F/wOA='
WHERE
key_id = '0db6f49c97f70a71876ddf84d3608e427f2b9a88379740822fd14840b166aed6'
AND (
token = 'QOg1TPACfW3wNxhY7KGWcBx7bHKZOikkbYmuu9F/wOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)