UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5xtYsG1VUnAWsb4oEYhzUOrmPPXP6XncMXmfCtl/LbU='
WHERE
key_id = 'f4ec7c31165717e36e5a2b0f9b38e637a04fe2541a575fb4238e3e83a29cd496'
AND (
token = '5xtYsG1VUnAWsb4oEYhzUOrmPPXP6XncMXmfCtl/LbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)