UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EDQD0+Z2kB1521cAIjz4/I2uA63Tni1Dd8XyQjze8Io='
WHERE
key_id = 'd043be0ca46ecd868f70ed88019492c4fbebf1e81a526578b1cfa1a3a9df7ff4'
AND (
token = 'EDQD0+Z2kB1521cAIjz4/I2uA63Tni1Dd8XyQjze8Io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)