UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Als2uPhnqpANQvllwz+8Jssnmp3Ahv0DZ7QyOyX6vw='
WHERE
key_id = '078dc3f85c6aca5ce540e4f88e31e9c9ae4b466d79dbc9d838359176cad05eea'
AND (
token = '4Als2uPhnqpANQvllwz+8Jssnmp3Ahv0DZ7QyOyX6vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)