UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4jlWklvrqPcz+MK0w3/uqA6aVSmHQy6I64439VGQmU='
WHERE
key_id = '4adae854e688d9146690e2fb7c379ba455ee9b06cf509c8e50f7915d80ff4ffb'
AND (
token = 'H4jlWklvrqPcz+MK0w3/uqA6aVSmHQy6I64439VGQmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)