UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b1l1VigEEa/xGDk+iVG/+yMa6FH1elKQAxCvU8RSrX8='
WHERE
key_id = '586d66410b249c70e9431b63bd246ebe8697632c940badd6e69da14124dcb961'
AND (
token = 'b1l1VigEEa/xGDk+iVG/+yMa6FH1elKQAxCvU8RSrX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)