UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TuC4OY9f0HlgS7SSEr2k5LCa7dwiVYns/Xdd9aYspo4='
WHERE
key_id = 'd6437a37a375e1737b01e11e1f72c33a9ae18abb1c240474882da52858c12dc0'
AND (
token = 'TuC4OY9f0HlgS7SSEr2k5LCa7dwiVYns/Xdd9aYspo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)