UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCTf2A+3VHUVoH0IMG8MJnM3eOaztoq77yVygUr1Y14='
WHERE
key_id = 'f828914e8df7b18ac303b9883c83a7668ce09aacc2a51e9e065fc5d9e5629f92'
AND (
token = 'xCTf2A+3VHUVoH0IMG8MJnM3eOaztoq77yVygUr1Y14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)