UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DIZWNqzhkrhIjTYbje50wgP5xXFJo/AGBm1YgRu2Yy8='
WHERE
key_id = 'ac72ed2e1e381225c1e7bc046befb296803f476e73955a5a5b614b4636ee40af'
AND (
token = 'DIZWNqzhkrhIjTYbje50wgP5xXFJo/AGBm1YgRu2Yy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)