UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F7UHhHTASUDrz44Xzm7hLGSAqtfP22qfxHCBAZ7SYDA='
WHERE
key_id = 'f395d93ee0b034ffa5ebf643d0e19694f69224162f1497532df4b7fd6c7c3fca'
AND (
token = 'F7UHhHTASUDrz44Xzm7hLGSAqtfP22qfxHCBAZ7SYDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)