UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UgfhLX0wNP3/siLdFlGcjVlaG0von+rPQnPQS5V0WsA='
WHERE
key_id = 'e31c57d42b9c198499a3dc4ac72419ef928db06940855e5a88c82fa83f7e7e68'
AND (
token = 'UgfhLX0wNP3/siLdFlGcjVlaG0von+rPQnPQS5V0WsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)